package com.tuling.springcloud;

import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;

/**
 * author: xl
 * time: 2018/6/11 11:33
 * description:
 **/
public class test {


    public static void main(String[] args) {
        Map map = new HashMap();
        map.put("0","[0]");
        map.put("1","( 0~ 1000]");
        map.put("2","[ 1000~ 2000]");
        map.put("3","[ 2000~ 3000]");
        map.put("4","[ 3000~ 4000]");
        map.put("5","[ 4000~ 5000]");
        map.put("6","[ 5000~ 6000]");
        map.put("7","[ 6000~ 7000]");
        map.put("8","[ 7000~ 8000]");
        map.put("9","[ 8000~ 9000]");
        map.put("A","[ 9000~ 10000]");
        map.put("B","[ 10000~ 11000]");
        map.put("C","[ 11000~ 12000]");
        map.put("D","[ 12000~ 13000]");
        map.put("E","[ 13000~ 14000]");
        map.put("F","[ 14000~ 15000]");
        map.put("G","[ 15000~ 16000]");
        map.put("H","[ 16000~ 17000]");
        map.put("I","[ 17000~ 18000]");
        map.put("J","[ 18000~ 19000]");
        map.put("K","[ 19000~ 20000]");
        map.put("L","[ 20000~ 22000]");
        map.put("M","[ 22000~ 24000]");
        map.put("N","[ 24000~ 26000]");
        map.put("O","[ 26000~ 28000]");
        map.put("P","[ 28000~ 30000]");
        map.put("Q","[ 30000~ 32000]");
        map.put("R","[ 32000~ 34000]");
        map.put("S","[ 34000~ 36000]");
        map.put("T","[ 36000~ 38000]");
        map.put("U","[ 38000~ 40000]");
        map.put("V","[ 40000~ 42000]");
        map.put("W","[ 42000~ 44000]");
        map.put("X","[ 44000~ 46000]");
        map.put("Y","[ 46000~ 48000]");
        map.put("Z","[ 48000~ 50000]");
        map.put("a","[ 50000~ 52000]");
        map.put("b","[ 52000~ 54000]");
        map.put("c","[ 54000~ 56000]");
        map.put("d","[ 56000~ 58000]");
        map.put("e","[ 58000~ 60000]");
        map.put("f","[ 60000~ 62000]");
        map.put("g","[ 62000~ 64000]");
        map.put("h","[ 64000~ 66000]");
        map.put("i","[ 66000~ 68000]");
        map.put("j","[ 68000~ 70000]");
        map.put("k","[ 70000~ 72000]");
        map.put("l","[ 72000~ 74000]");
        map.put("m","[ 74000~ 76000]");
        map.put("n","[ 76000~ 78000]");
        map.put("o","[ 78000~ 80000]");
        map.put("p","[ 80000~ 90000]");
        map.put("q","[ 90000~100000]");
        map.put("r","[100000~110000]");
        map.put("s","[110000~120000]");
        map.put("t","[120000~130000]");
        map.put("u","[130000~140000]");
        map.put("v","[140000~150000]");
        map.put("w","[150000~160000]");
        map.put("x","[160000~170000]");
        map.put("y",">=170000");
        map.put("z","未查得");



        Iterator iterator = map.entrySet().iterator();
        while (iterator.hasNext()) {
            Map.Entry entry = (Map.Entry) iterator.next();
            String key =(String) entry.getKey();
            String val =(String) entry.getValue();
            String str ="INSERT INTO `credit_report`.`rp_sys_dict` ( `DATA_TYPE`, `DATA_CODE`, `DATA_VALUE`, `SORT_NO`, `STATUS`, `DATA_DESC`, `DATA_VALID`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`) \n" +
                    "VALUES ('variableSet', 'xiaoZ_consume_result', '"+val +"', NULL, '1', '"+key +"', '1', NULL, NULL, NULL, NULL);";
            System.out.println(str);

        }






    }

}
